Tabela LCareTakerAddress

Definicja tabeli LCareTakerAddress

Name

LCareTakerAddress

Code

LCareTakerAddress

Comment

PL: Polaczenie opiekuna z danymi adresowymi
EN: Link between curator and address data


Lista kolumn tabeli LCareTakerAddress

Name

Code

AddressID

AddressID

CareTakerID

CareTakerID

StartDT

StartDT

StopDT

StopDT


Kolumna AddressID tabeli LCareTakerAddress

Definicja kolumny AddressID tabeli LCareTakerAddress

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna CareTakerID tabeli LCareTakerAddress

Definicja kolumny CareTakerID tabeli LCareTakerAddress

Name

CareTakerID

Code

CareTakerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LCareTakerAddress

Definicja kolumny StartDT tabeli LCareTakerAddress

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LCareTakerAddress

Definicja kolumny StopDT tabeli LCareTakerAddress

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LCareTakerAddress

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LCareTakerAddress

Definicja klucza Identifier_1 tabeli LCareTakerAddress

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment